<template>
  <div class="container">
    <div>
      <el-row :gutter="25">
        <el-col :span="6">
          <el-form ref="form" :model="form" label-width="120px">
            <el-form-item label="设施名称：">
              <el-input
                v-model="select.name"
                placeholder="请输入设施名称"
                style="width: 150px"
              ></el-input>
            </el-form-item>
          </el-form>
        </el-col>
        <el-col :span="14">
          <el-form ref="form" :model="form" style="float: left">
            <el-form-item>
              <el-button size="mini" type="primary" @click="screeningData"
                >查 询</el-button
              >
              <el-button size="mini" type="success" @click="handleAdd"
                >新 增</el-button
              >

              <el-button style="padding: 0; border: 0">
                <el-upload
                  action="/上传文件的接口"
                  :on-change="onChange"
                  :auto-upload="false"
                  :show-file-list="false"
                  accept=".xls, .xlsx"
                  class="upload"
                >
                  <el-button size="mini" type="success">导 入</el-button>
                </el-upload>
              </el-button>
              <el-button size="mini" type="warning" @click="exportExcel"
                >导 出</el-button
              >
            </el-form-item>
          </el-form>
        </el-col>
      </el-row>
    </div>
    <el-table
      highlight-current-row
      :data="
        tableData.slice((currentPage - 1) * pageSize, currentPage * pageSize)
      "
      @row-dblclick="dblClickRow"
    >
      <!-- <el-table-column  prop="ID" label="站点编号" align="center" ></el-table-column> -->
      <el-table-column
        prop="NAME"
        label="点位名称"
        align="center"
      ></el-table-column>
      <el-table-column
        prop="LONGITUDE"
        label="经度"
        align="center"
      ></el-table-column>
      <el-table-column
        prop="LATITUDE"
        label="纬度"
        align="center"
      ></el-table-column>
      <el-table-column
        prop="LOCATION"
        label="位置"
        align="center"
      ></el-table-column>
      <!-- <el-table-column  prop="CLIENT_NO" label="区域ID" align="center" ></el-table-column> -->
      <el-table-column
        prop="TYPE_NAME"
        label="类型"
        align="center"
      ></el-table-column>
      <el-table-column label="操作" align="center">
        <template slot-scope="scope">
          <!-- <el-button type="text" @click="dblClickRow"
            >定位</el-button
          > -->
          <el-button type="text" @click="handleEdit(scope.$index, scope.row)"
            >编辑</el-button
          >
          <el-button
            type="text"
            @click="handleDelete(scope.$index, scope.row)"
            style="color: red"
            >删除</el-button
          >
        </template>
      </el-table-column>
    </el-table>
    <div class="pagination">
      <el-pagination
        background
        layout="total, sizes, prev, pager, next, jumper"
        :current-page="currentPage"
        :page-size="pageSize"
        :total="tableData.length"
        @size-change="handleSizeChange"
        @current-change="handlePageChange"
      ></el-pagination>
    </div>

    <!-- 弹出框 -->
    <el-dialog
      :title="addDialogTitle"
      :visible.sync="isVisibleEdit"
      width="50%"
      :modal="false"
    >
      <el-form ref="form" :model="form" label-width="100px" class="flex">
        <el-form-item label="设施名称：" class="wid50">
          <el-input
            v-model="form.NAME"
            placeholder="请输入设施名称"
            class="handle-input mr10"
          ></el-input>
        </el-form-item>
        <el-form-item label="经度：" class="wid50">
          <el-input
            v-model="form.LONGITUDE"
            placeholder="请输入经度"
            class="handle-input mr10"
          ></el-input>
        </el-form-item>
        <el-form-item label="纬度：" class="wid50">
          <el-input
            v-model="form.LATITUDE"
            placeholder="请输入纬度"
            class="handle-input mr10"
          ></el-input>
        </el-form-item>
        <el-form-item label="位置：" class="wid50">
          <el-input
            v-model="form.LOCATION"
            placeholder="请输入位置"
            class="handle-input mr10"
          ></el-input>
        </el-form-item>
        <el-form-item label="组织机构：" class="wid50">
          <el-select
            v-model="form.CLIENT_NO"
            value-key="id"
            placeholder="请选择"
          >
            <el-option
              v-for="item in selectClientInfoList"
              :key="item.CLIENT_NO"
              :label="item.CLIENT_NAME"
              date-name="item.CLIENT_NAME"
              :value="item.CLIENT_NO"
            >
            </el-option>
          </el-select>
        </el-form-item>
        <el-form-item label="类型：" class="wid50">
          <el-select v-model="form.TYPE" placeholder="请选择">
            <el-option
              v-for="item in type"
              :key="item.typetitle"
              :label="item.typetitle"
              :value="item.typeindex"
            >
            </el-option>
          </el-select>
        </el-form-item>
      </el-form>

      <span slot="footer" class="dialog-footer">
        <el-button @click="isVisibleEdit = false">取 消</el-button>
        <el-button type="primary" @click="handleSubmit()">确 定</el-button>
      </span>
    </el-dialog>
  </div>
</template>
<script>
import '@/assets/css/common.css'

import export2Excel from '@/utils/exportExcel/index.js'
import OSS from 'ali-oss';
import { time } from 'echarts';
import eventBus from '@/eventBus.js'


export default {
  data () {

    return {
      clientData: [],
      currentPage: 1, //初始页
      pageSize: 10,    //    每页的数据
      originalData: [],
      tableData: [],
      selectClientInfoList: [],
      expireData: [],
      select: {
        name: ''
      },
      isVisibleEdit: false,
      showBigDialogDate: true,
      TYPElevel: [
        { TYPEltitle: '其他垃圾设施' },
        { TYPEltitle: '厨余垃圾设施' },
        { TYPEltitle: '可回收垃圾设施' },
        { TYPEltitle: '有害垃圾设施' }
      ],
      type: [{
        typetitle: '加水点',
        typeindex: 'A'
      },
      {
        typetitle: '排污点',
        typeindex: 'P'
      }],
      form: {
        DW: "",
        CPH: "",
        MODEL: "",
        PERSON: "",
        BUYTIME: "",
        EXPLAIN: "",
        USEDEPTNAME: "",
        USEDEPTID: "",
        VOWNER: "",
        BRAND: "",
        VIN: "",
        ENGINENUM: "",
        DISCHARGERATE: "",
        VCONDITION: "",
        PRICE: "",
        CLIENT_NO: [],
        USE: "",
      },
      showBigDialogVisible: false,
      srcBig: '',
      //图片上传
      fileList: [],
      VehicleUrl: '', //存上传后的设施图片url
      CBPicUrl: '', //存上传后的车本图片url
      dataObj: {
        region: 'oss-cn-beijing',//我的存储是北京，可根据具体配置自行修改
        accessKeyId: 'LTAISI12uxTRFccz',
        accessKeySecret: 'cQAvLIZ9JizT5RXRNPBVcXfg3iURD8',
        bucket: 'photo-srw-hb2',
      }, //存签名信息
      baseAli: 'oss-cn-beijing.aliyuncs.com',
      addDialogTitle: ''
    }
  },
  created () {
    if (localStorage.getItem('CTYPE') == '0') {
      this.rolelevel.shift()
    } else if (localStorage.getItem('CTYPE') != '-1') {
      this.rolelevel = []
    }
    this.getClientRoleList()
  },
  mounted () {
    this.getlistdata()
  },
  methods: {
    //获取设施列表
    async getlistdata () {
      var url = '/CarService/getPlaceWaterInfo?CLIENT_NO=' + localStorage.getItem('CLIENT_NO')
      const { data } = await this.$Http.get(url)
      this.originalData = data
      this.screeningData()
  
    },
    // 获取组织机构名
    async getClientRoleList () {
      var url = '/CarService/getAbleAddPlaceInfo?CLIENT_NO=' + localStorage.getItem('CLIENT_NO')
      const { data } = await this.$Http.get(url)
      this.selectClientInfoList = data
    },
    // 给组织机构名称下拉列表传值
    changClient (e) {
      this.form.CLIENT_NO_select = ''
      this.getClientRoleList(e)
    },
    change (e) {
      this.$forceUpdate()
    },
    // 导入Excel
    onChange (file, fileList) {
      //  console.log(fileList);
      this.fileData = file; // 保存当前选择文件
      this.readExcel(); // 调用读取数据的方法
    },
    // 读取数据
    readExcel (e) {
      let that = this;
      const files = that.fileData;
      console.log(files);
      if (!files) {
        //如果没有文件
        return false;
      } else if (!/\.(xls|xlsx)$/.test(files.name.toLowerCase())) {
        this.$message.error("上传格式不正确，请上传xls或者xlsx格式");
        return false;
      }
      const fileReader = new FileReader();
      console.log(fileReader)
      fileReader.onload = ev => {
        try {
          const data = ev.target.result;
          //  console.log(ev.target)
          //  console.log(this);
          const workbook = this.XLSX.read(data, {
            type: "binary"// 以字符编码的方式解析
          });

          if (workbook.SheetNames.length >= 1) {
            //  this.$message({
            //    message: "导入数据表格成功",
            //    showClose: true,
            //    type: "success"
            //  });

            const wsname = workbook.SheetNames[0]; //取第一张表
            const ws = this.XLSX.utils.sheet_to_json(workbook.Sheets[wsname]); //生成json表格内容
            console.log(ws)
            this.inputExcelDataLength = ws.length
            this.fullscreenLoading = this.$loading({
              lock: true,
              text: 'Loading',
              spinner: 'el-icon-loading',
              background: 'rgba(0, 0, 0, 0.7)'
            })
            for (let i = 0, len = ws.length; i < len; i++) {
              var item = ws[i]
              //   var sheetData = {
              //     VID: item['居民电话'],
              //     RUBBISH_NAME: item["垃圾品名"],
              //     WEIGHT: item["垃圾称重"],
              //     photo: '',
              //     LONGITUDE: 0,
              //     LATITUDE: 0
              //   }
              //   let exceldata =  []
              //   exceldata.push(sheetData)
              this.addWeight(item)
            }
          } else {
            this.$message.error("未读取到表格内容");
          }
        } catch (e) {
          return false;
        }
      };
      // 如果为原生 input 则应是 files[0]
      fileReader.readAsBinaryString(files.raw);
    },
    async addWeight (item) {
      this.$axios({
        url: 'CarService/AddPlaceWaterInfo',
        method: 'post',
        data: {
          NAME: item['点位名称'],
          LONGITUDE: item['经度'],
          LATITUDE: item['纬度'],
          LOCATION: item['位置'],
          CLIENT_NO: item['区域ID'],
          TYPE: item['类型'],
        }
      }).then(res => {
        console.log(res)
        this.inputExcelDataIndex++
        if (res.data.IsSucess) {
          this.fullscreenLoading.close()
          this.$message.success('表格文件导入成功')
          this.getlistdata()
        } else {
          this.fullscreenLoading.close()
          this.$message.error('表格文件导入失败' + '，' + res.data.Message);

        }
        if (this.inputExcelDataIndex == this.inputExcelDataLength) {
          this.fullscreenLoading.close()
          if (this.strError.length == 0) {
            this.$message.success('表格文件导入成功')
          } else {
            // this.$message.error('表格文件导入结束<br/>' + this.strError);
            this.$message({
              message: '表格文件导入结束，' + this.strError,
              type: 'error',
              duration: 5000
            })
          }
          this.getlistdata()
        }
      })
      //   })
    },
    // 导出Excel
    exportExcel () {
      let excelName = '设施信息'
      const tHeader = ['点位名称', '经度', '纬度', '位置', '区域ID', '类型']
      const filterVal = ['NAME', 'LONGITUDE', 'LATITUDE', 'LOCATION', 'CLIENT_NO', 'TYPE_NAME']
      export2Excel(tHeader, filterVal, this.tableData, excelName)
    },
    // 打开新增窗口
    handleAdd () {
      this.addDialogTitle = '新增设施信息'
      //清空编辑框
      this.form = {}
      //展示窗口
      this.isVisibleEdit = true;
      // this.idEdit = false;
    },
    // 打开编辑窗口
    handleEdit (index, row) {
      this.form = Object.assign({}, row);
      this.form.CLIENT_NO_select = this.form.USERNAME
      this.addDialogTitle = '编辑设施信息'
      this.isVisibleEdit = true;
    },
    // 点击保存，判断是新增还是编辑操作
    handleSubmit () {
      if (this.addDialogTitle == '新增设施信息') {
        this.saveAdd()
      } else {
        this.saveEdit()
      }
    },
    // 新增保存
    async saveAdd () {
      // console.log(this.addform)
      this.$axios({
        url: '/CarService/AddPlaceWaterInfo',
        method: 'post',
        data: {
          NAME: this.form.NAME,
          LOCATION: this.form.LOCATION,
          LONGITUDE: this.form.LONGITUDE,
          LATITUDE: this.form.LATITUDE,
          CLIENT_NO: this.form.CLIENT_NO,
          TYPE: this.form.TYPE,
        },

      }).then((res) => {
        console.log(this.data)
        console.log(res)
        if (res.data.IsSucess) {
          this.$message.success('新增成功');
          this.isVisibleEdit = false
          this.getlistdata()
        } else {
          this.$message.error('新增失败');
        }
      })

    },
    // 保存编辑
    async saveEdit () {
      this.$axios({
        url: 'CarService/UpdataPlaceWaterInfo',
        method: 'post',
        data: {
          //  ID: this.form.ID,
          NAME: this.form.NAME,
          LOCATION: this.form.LOCATION,
          LONGITUDE: this.form.LONGITUDE,
          LATITUDE: this.form.LATITUDE,
          CLIENT_NO: this.form.CLIENT_NO,
          TYPE: this.form.TYPE,
        },

      }).then((res) => {
        console.log(this.data)
        console.log(res)
        if (res.data.IsSucess) {
          this.$message.success('编辑成功');
          this.isVisibleEdit = false
          this.getlistdata()
        } else {
          this.$message.error('编辑失败');
        }
      })
    },
    // 删除设施信息
    async handleDelete (index, row) {
      const confirmResult = await this.$confirm('确定删除？', '提示', {
        confirmButtonText: '确定',
        cancelButtonText: '取消',
        type: 'warning'
      }).catch(err => err)
      if (confirmResult == 'confirm') {
        const params = {
          ID: row.NAME,
        }
        const { data } = await this.$Http.get('CarService/DeletePlaceWaterInfo', { params })
        if (data.IsSucess) {
          this.$message.success('删除成功')
          this.isVisibleEdit = false
          this.getlistdata()
        } else {
          this.$message.error('删除失败');
        }  
      }else{
        this.$message.info('取消删除')
        this.isVisibleEdit = false
      }
      
    },
    // 模糊查询
    screeningData () {
      this.currentPage = 1;
      this.tableData = [];
      // this.tableData = this.originalData
      // if (this.select.name) this.tableData = this.tableData.filter(item => item.NAME.includes(this.select.name))
      // console.log(this.select.name)
      var listJiashui = [], listPaiwu = [];
      this.originalData.forEach(item => {
        if (!item.NAME.includes(this.select.name)) {
          return;
        }
        switch (item.TYPE) {
            case 'A':
              // item.img = 'duli'
              item.TYPE_NAME = '加水点'
              listJiashui.push(item);
              break;
            case 'P':
              // item.img = 'fujian'
              item.TYPE_NAME = '排污点'
              listPaiwu.push(item);
              break;
    
          }
          this.tableData.push(item);
      });
      // eventBus.$emit('mapData_Toilet', this.tableData)
      eventBus.$emit('mapData_Water', [listJiashui, listPaiwu])
      // this.tableData = this.originalData
      // if (this.select.name) this.tableData = this.tableData.filter(item => item.NAME.includes(this.select.name))
      // console.log(this.select.name)
      // eventBus.$emit('mapData_Water', this.tableData)
    },
    // 分页导航
    handlePageChange (currentPage) {
      this.currentPage = currentPage;
      // console.log(this.currentPage)
      // this.$set(this.query, 'pageIndex', val);
      // this.getlistdata();
    },
    handleSizeChange (size) {
      this.pageSize = size;
      console.log(this.pageSize)
    },
    // 放大图片
    bigImage (row) {
      this.srcBig = row.VehiclePicPath
      this.showBigDialogVisible = true
    },
    handleClose () {
      this.showBigDialogVisible = false;
    },
    // 限制用户上传的图片格式和大小
    beforeAvatarUpload (file) {
      const isJPG = file.type === 'image/jpeg';
      const isLt2M = file.size / 1024 / 1024 < 2
      if (!isJPG) {
        this.$message.error('上传头像图片只能是 JPG 格式!');
      }
      if (!isLt2M) {
        this.$message.error('上传头像图片大小不能超过 2MB!');
      }
      return isJPG && isLt2M;
    },
    // 点击上传设施图片按钮
    clickVehicle () {
      this.$refs.VehicleFile.click();

    },
    changeVehicle () {
      this.afterRead1(this.$refs.VehicleFile.files[0]);
      this.$refs.VehicleFile.value = null; // 移除文件，可以保证上传同样的文件时，也会触发change事件
    },
    // 上传设施图片
    afterRead1 (file) {
      return new Promise((resolve, reject) => {
        // 此时可以自行将文件上传至服务器
        const that = this
        let client = new OSS(this.dataObj)
        const fileName = file.name
        //定义唯一的文件名，打印出来的uid其实就是时间戳
        //client 是第一步中的 client
        client
          .multipartUpload(fileName, file)
          .then((result) => {
            //下面是如果对返回结果再进行处理，根据项目需要
            // console.log(result)
            that.VehicleUrl =
              'http://' +
              result.bucket +
              '.' +
              that.baseAli +
              '/' +
              result.name
            console.log(that.VehicleUrl)
            resolve()
          })
          .catch((err) => {
            console.log('err:', err)
            reject()
          })
      })
    },

    // 点击上传车本图片按钮
    clickCBPic () {
      this.$refs.CBPicFile.click();

    },
    changeCBPic () {
      this.afterRead2(this.$refs.CBPicFile.files[0]);
      this.$refs.CBPicFile.value = null; // 移除文件，可以保证上传同样的文件时，也会触发change事件
    },
    // 上传车本图片
    afterRead2 (file) {
      return new Promise((resolve, reject) => {
        // 此时可以自行将文件上传至服务器
        const that = this
        let client = new OSS(this.dataObj)
        const fileName = file.name
        //定义唯一的文件名，打印出来的uid其实就是时间戳
        //client 是第一步中的 client
        client
          .multipartUpload(fileName, file)
          .then((result) => {
            //下面是如果对返回结果再进行处理，根据项目需要
            // console.log(result)
            that.CBPicUrl =
              'http://' +
              result.bucket +
              '.' +
              that.baseAli +
              '/' +
              result.name
            console.log(that.CBPicUrl)
            resolve()
          })
          .catch((err) => {
            console.log('err:', err)
            reject()
          })
      })
    },
    afterRead (file) {
      return new Promise((resolve, reject) => {
        // 此时可以自行将文件上传至服务器
        const that = this
        let client = new OSS(this.dataObj)
        const fileName = file.name
        //定义唯一的文件名，打印出来的uid其实就是时间戳
        //client 是第一步中的 client
        client
          .multipartUpload(fileName, file)
          .then((result) => {
            //下面是如果对返回结果再进行处理，根据项目需要
            // console.log(result)
            that.tempUrl =
              'http://' +
              result.bucket +
              '.' +
              that.baseAli +
              '/' +
              result.name
            console.log(that.tempUrl)
            resolve()
          })
          .catch((err) => {
            console.log('err:', err)
            reject()
          })
      })
    },
    handleAvatarSuccess (res, file) {
      this.imageUrl = URL.createObjectURL(file.raw)
    },
    // 双击表格某一行
    dblClickRow (row) {
      eventBus.$emit('mapDBrowWater', row)
    },
  }
}
</script>
<style>
.container {
  overflow-y: auto;
  height: calc(100% - 50px);
  border: 0px;
}
.el-col-6 {
  min-width: 400px;
  min-height: 50px;
}
.el-table th {
  height: 40px;
}
.el-form-item label {
  width: 80px;
}
/* .el-upload--text {
  width: 300px;
} */
</style>